Marking Scheme[Total: 10 Marks]

Task

Description

Mark

1

Correct Dim statements

1

2

Create command buttons to access the two tasks

1

3

Create a new worksheet called Recording Formulas and add it to the end of the list of Worksheets

1

4

Find the formulas and record the information.
Loop through ALL worksheets in workbook

2

5

Loop through only those cells that are used (i.e. have data in them):

1

6

Indentify and process only cells that have a formula

1

7

Record name of worksheet from where the formula came from
Record the actual value of the formula

1

8

Widen the columns if necessary:

1

9

Write a subroutine to delete the new sheet:

1

 

=======

Total

10